<html>
<head>
<title>Retribution High Scores</title>
<script type = "text/javascript">
<!--
document.bgColor = '#CCCCCC'
//-->
</script>
</head>
<body>
<?php
$con = mysql_connect("localhost", "solomon", "mikesolomon1");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("solomon", $con);

$result = mysql_query("SELECT * FROM highScore ORDER BY score DESC LIMIT 10");

echo "<table border = '1' width = '100%'>
<tr>
<td width = '25%'></td>
<th>Firstname</th>
<th>Score</th>
<td width = '25%'></td>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr><td width = '25%'></td>";
  echo "<td align = 'center' width = '25%'>" . $row['Name'] . "</td>";
  echo "<td align = 'center' width = '25%'>" . $row['Score'] . "</td>";
  echo "<td width = '25%'></td></tr>";
  }
echo "</table>";
mysql_free_result($result);
mysql_close($con)
?>
<br /><br />
<p><<-- Click <a href = "http://csserver.ucd.ie/~s04bf1d5/retribution/Home.html">Here</a> to return to the homepage</p>
</body>
</html>
